Dataset statistics
| Number of variables | 38 |
|---|---|
| Number of observations | 7043 |
| Missing cells | 26972 |
| Missing cells (%) | 10.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.0 MiB |
| Average record size in memory | 304.0 B |
Variable types
| Categorical | 10 |
|---|---|
| Numeric | 15 |
| Boolean | 13 |
Customer ID has a high cardinality: 7043 distinct values | High cardinality |
City has a high cardinality: 1106 distinct values | High cardinality |
Zip Code is highly correlated with Latitude and 1 other fields | High correlation |
Latitude is highly correlated with Zip Code and 2 other fields | High correlation |
Longitude is highly correlated with Zip Code and 1 other fields | High correlation |
Tenure in Months is highly correlated with Offer and 7 other fields | High correlation |
Avg Monthly Long Distance Charges is highly correlated with Total Long Distance Charges | High correlation |
Monthly Charge is highly correlated with Phone Service and 7 other fields | High correlation |
Total Charges is highly correlated with Tenure in Months and 10 other fields | High correlation |
Total Long Distance Charges is highly correlated with Tenure in Months and 3 other fields | High correlation |
Total Revenue is highly correlated with Tenure in Months and 10 other fields | High correlation |
Age is highly correlated with Avg Monthly GB Download | High correlation |
Avg Monthly GB Download is highly correlated with Age | High correlation |
Streaming Movies is highly correlated with Streaming TV and 4 other fields | High correlation |
Customer Status is highly correlated with Tenure in Months and 2 other fields | High correlation |
Internet Service is highly correlated with Monthly Charge and 1 other fields | High correlation |
Churn Category is highly correlated with Churn Reason | High correlation |
Online Security is highly correlated with Internet Service | High correlation |
Internet Type is highly correlated with Monthly Charge | High correlation |
Online Backup is highly correlated with Tenure in Months and 2 other fields | High correlation |
Unlimited Data is highly correlated with Total Extra Data Charges | High correlation |
Streaming Music is highly correlated with Streaming TV and 1 other fields | High correlation |
Premium Tech Support is highly correlated with Internet Service | High correlation |
Multiple Lines is highly correlated with Monthly Charge and 2 other fields | High correlation |
Phone Service is highly correlated with Monthly Charge | High correlation |
Churn Reason is highly correlated with Latitude and 1 other fields | High correlation |
Streaming TV is highly correlated with Streaming Movies and 4 other fields | High correlation |
Device Protection Plan is highly correlated with Tenure in Months and 2 other fields | High correlation |
Married is highly correlated with Number of Referrals | High correlation |
Number of Referrals is highly correlated with Married | High correlation |
Offer is highly correlated with Tenure in Months and 4 other fields | High correlation |
Contract is highly correlated with Tenure in Months and 3 other fields | High correlation |
Total Extra Data Charges is highly correlated with Unlimited Data | High correlation |
Avg Monthly Long Distance Charges has 682 (9.7%) missing values | Missing |
Multiple Lines has 682 (9.7%) missing values | Missing |
Internet Type has 1526 (21.7%) missing values | Missing |
Avg Monthly GB Download has 1526 (21.7%) missing values | Missing |
Online Security has 1526 (21.7%) missing values | Missing |
Online Backup has 1526 (21.7%) missing values | Missing |
Device Protection Plan has 1526 (21.7%) missing values | Missing |
Premium Tech Support has 1526 (21.7%) missing values | Missing |
Streaming TV has 1526 (21.7%) missing values | Missing |
Streaming Movies has 1526 (21.7%) missing values | Missing |
Streaming Music has 1526 (21.7%) missing values | Missing |
Unlimited Data has 1526 (21.7%) missing values | Missing |
Churn Category has 5174 (73.5%) missing values | Missing |
Churn Reason has 5174 (73.5%) missing values | Missing |
Customer ID is uniformly distributed | Uniform |
Customer ID has unique values | Unique |
Number of Dependents has 5416 (76.9%) zeros | Zeros |
Number of Referrals has 3821 (54.3%) zeros | Zeros |
Total Refunds has 6518 (92.5%) zeros | Zeros |
Total Extra Data Charges has 6315 (89.7%) zeros | Zeros |
Total Long Distance Charges has 682 (9.7%) zeros | Zeros |
Reproduction
| Analysis started | 2022-11-27 14:08:05.228891 |
|---|---|
| Analysis finished | 2022-11-27 14:08:21.253795 |
| Duration | 16.02 seconds |
| Software version | pandas-profiling v3.3.0 |
| Download configuration | config.json |
| Distinct | 7043 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.1 KiB |
| 0002-ORFBO | 1 |
|---|---|
| 6616-AALSR | 1 |
| 6625-UTXEW | 1 |
| 6625-IUTTT | 1 |
| 6625-FLENO | 1 |
| Other values (7038) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 70430 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 7043 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 0002-ORFBO |
|---|---|
| 2nd row | 0003-MKNFE |
| 3rd row | 0004-TLHLJ |
| 4th row | 0011-IGKFF |
| 5th row | 0013-EXCHZ |
Common Values
| Value | Count | Frequency (%) |
| 0002-ORFBO | 1 | < 0.1% |
| 6616-AALSR | 1 | < 0.1% |
| 6625-UTXEW | 1 | < 0.1% |
| 6625-IUTTT | 1 | < 0.1% |
| 6625-FLENO | 1 | < 0.1% |
| 6624-JDRDS | 1 | < 0.1% |
| 6621-YOBKI | 1 | < 0.1% |
| 6621-NRZAK | 1 | < 0.1% |
| 6620-JDYNW | 1 | < 0.1% |
| 6620-HVDUJ | 1 | < 0.1% |
| Other values (7033) | 7033 |
Length
| Value | Count | Frequency (%) |
| 0002-orfbo | 1 | < 0.1% |
| 0019-efaep | 1 | < 0.1% |
| 0011-igkff | 1 | < 0.1% |
| 0013-exchz | 1 | < 0.1% |
| 0013-mhzwf | 1 | < 0.1% |
| 0013-smeoe | 1 | < 0.1% |
| 0014-bmaqu | 1 | < 0.1% |
| 0015-uocoj | 1 | < 0.1% |
| 0016-qljis | 1 | < 0.1% |
| 0017-dinoc | 1 | < 0.1% |
| Other values (7033) | 7033 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 7043 | 10.0% |
| 2 | 2901 | 4.1% |
| 9 | 2881 | 4.1% |
| 6 | 2870 | 4.1% |
| 7 | 2836 | 4.0% |
| 0 | 2831 | 4.0% |
| 8 | 2812 | 4.0% |
| 5 | 2810 | 4.0% |
| 3 | 2791 | 4.0% |
| 1 | 2726 | 3.9% |
| Other values (27) | 37929 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 35215 | |
| Decimal Number | 28172 | |
| Dash Punctuation | 7043 | 10.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 1442 | 4.1% |
| H | 1396 | 4.0% |
| B | 1393 | 4.0% |
| S | 1386 | 3.9% |
| V | 1382 | 3.9% |
| T | 1374 | 3.9% |
| Z | 1368 | 3.9% |
| C | 1368 | 3.9% |
| F | 1363 | 3.9% |
| L | 1363 | 3.9% |
| Other values (16) | 21380 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 2901 | |
| 9 | 2881 | |
| 6 | 2870 | |
| 7 | 2836 | |
| 0 | 2831 | |
| 8 | 2812 | |
| 5 | 2810 | |
| 3 | 2791 | |
| 1 | 2726 | |
| 4 | 2714 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 7043 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 35215 | |
| Latin | 35215 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 1442 | 4.1% |
| H | 1396 | 4.0% |
| B | 1393 | 4.0% |
| S | 1386 | 3.9% |
| V | 1382 | 3.9% |
| T | 1374 | 3.9% |
| Z | 1368 | 3.9% |
| C | 1368 | 3.9% |
| F | 1363 | 3.9% |
| L | 1363 | 3.9% |
| Other values (16) | 21380 |
Common
| Value | Count | Frequency (%) |
| - | 7043 | |
| 2 | 2901 | |
| 9 | 2881 | |
| 6 | 2870 | |
| 7 | 2836 | |
| 0 | 2831 | |
| 8 | 2812 | 8.0% |
| 5 | 2810 | 8.0% |
| 3 | 2791 | 7.9% |
| 1 | 2726 | 7.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 70430 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 7043 | 10.0% |
| 2 | 2901 | 4.1% |
| 9 | 2881 | 4.1% |
| 6 | 2870 | 4.1% |
| 7 | 2836 | 4.0% |
| 0 | 2831 | 4.0% |
| 8 | 2812 | 4.0% |
| 5 | 2810 | 4.0% |
| 3 | 2791 | 4.0% |
| 1 | 2726 | 3.9% |
| Other values (27) | 37929 |
Gender
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.1 KiB |
| Male | |
|---|---|
| Female |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.990487008 |
| Min length | 4 |
Characters and Unicode
| Total characters | 35148 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Female |
|---|---|
| 2nd row | Male |
| 3rd row | Male |
| 4th row | Male |
| 5th row | Female |
Common Values
| Value | Count | Frequency (%) |
| Male | 3555 | |
| Female | 3488 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| male | 3555 | |
| female | 3488 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 10531 | |
| a | 7043 | |
| l | 7043 | |
| M | 3555 | 10.1% |
| F | 3488 | 9.9% |
| m | 3488 | 9.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 28105 | |
| Uppercase Letter | 7043 | 20.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 10531 | |
| a | 7043 | |
| l | 7043 | |
| m | 3488 | 12.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 3555 | |
| F | 3488 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 35148 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 10531 | |
| a | 7043 | |
| l | 7043 | |
| M | 3555 | 10.1% |
| F | 3488 | 9.9% |
| m | 3488 | 9.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 35148 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 10531 | |
| a | 7043 | |
| l | 7043 | |
| M | 3555 | 10.1% |
| F | 3488 | 9.9% |
| m | 3488 | 9.9% |
| Distinct | 62 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46.50972597 |
| Minimum | 19 |
|---|---|
| Maximum | 80 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 19 |
|---|---|
| 5-th percentile | 21 |
| Q1 | 32 |
| median | 46 |
| Q3 | 60 |
| 95-th percentile | 75 |
| Maximum | 80 |
| Range | 61 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 16.75035166 |
|---|---|
| Coefficient of variation (CV) | 0.3601472876 |
| Kurtosis | -1.00284948 |
| Mean | 46.50972597 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 0.1621864487 |
| Sum | 327568 |
| Variance | 280.5742806 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 42 | 156 | 2.2% |
| 47 | 153 | 2.2% |
| 40 | 150 | 2.1% |
| 44 | 148 | 2.1% |
| 23 | 146 | 2.1% |
| 56 | 144 | 2.0% |
| 62 | 143 | 2.0% |
| 35 | 142 | 2.0% |
| 21 | 140 | 2.0% |
| 33 | 139 | 2.0% |
| Other values (52) | 5582 |
| Value | Count | Frequency (%) |
| 19 | 127 | |
| 20 | 127 | |
| 21 | 140 | |
| 22 | 130 | |
| 23 | 146 | |
| 24 | 109 | |
| 25 | 138 | |
| 26 | 115 | |
| 27 | 132 | |
| 28 | 119 |
| Value | Count | Frequency (%) |
| 80 | 66 | |
| 79 | 76 | |
| 78 | 63 | |
| 77 | 72 | |
| 76 | 69 | |
| 75 | 74 | |
| 74 | 76 | |
| 73 | 85 | |
| 72 | 58 | |
| 71 | 68 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.0 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 3641 | |
| True | 3402 |
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4686923186 |
| Minimum | 0 |
|---|---|
| Maximum | 9 |
| Zeros | 5416 |
| Zeros (%) | 76.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 3 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.9628019509 |
|---|---|
| Coefficient of variation (CV) | 2.054230276 |
| Kurtosis | 4.446357934 |
| Mean | 0.4686923186 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.109931981 |
| Sum | 3301 |
| Variance | 0.9269875967 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5416 | |
| 1 | 553 | 7.9% |
| 2 | 531 | 7.5% |
| 3 | 517 | 7.3% |
| 5 | 10 | 0.1% |
| 4 | 9 | 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| 9 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 5416 | |
| 1 | 553 | 7.9% |
| 2 | 531 | 7.5% |
| 3 | 517 | 7.3% |
| 4 | 9 | 0.1% |
| 5 | 10 | 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 7 | 2 | < 0.1% |
| 6 | 3 | < 0.1% |
| 5 | 10 | 0.1% |
| 4 | 9 | 0.1% |
| 3 | 517 | 7.3% |
| 2 | 531 | 7.5% |
| 1 | 553 | 7.9% |
| 0 | 5416 |
| Distinct | 1106 |
|---|---|
| Distinct (%) | 15.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.1 KiB |
| Los Angeles | 293 |
|---|---|
| San Diego | 285 |
| San Jose | 112 |
| Sacramento | 108 |
| San Francisco | 104 |
| Other values (1101) |
Length
| Max length | 22 |
|---|---|
| Median length | 19 |
| Mean length | 9.203464433 |
| Min length | 3 |
Characters and Unicode
| Total characters | 64820 |
|---|---|
| Distinct characters | 52 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Frazier Park |
|---|---|
| 2nd row | Glendale |
| 3rd row | Costa Mesa |
| 4th row | Martinez |
| 5th row | Camarillo |
Common Values
| Value | Count | Frequency (%) |
| Los Angeles | 293 | 4.2% |
| San Diego | 285 | 4.0% |
| San Jose | 112 | 1.6% |
| Sacramento | 108 | 1.5% |
| San Francisco | 104 | 1.5% |
| Fresno | 61 | 0.9% |
| Long Beach | 60 | 0.9% |
| Oakland | 52 | 0.7% |
| Escondido | 51 | 0.7% |
| Stockton | 44 | 0.6% |
| Other values (1096) | 5873 |
Length
| Value | Count | Frequency (%) |
| san | 718 | 6.9% |
| los | 337 | 3.3% |
| angeles | 293 | 2.8% |
| diego | 285 | 2.8% |
| santa | 181 | 1.8% |
| valley | 171 | 1.7% |
| beach | 169 | 1.6% |
| city | 150 | 1.5% |
| sacramento | 116 | 1.1% |
| jose | 112 | 1.1% |
| Other values (1110) | 7807 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 6946 | 10.7% |
| e | 6111 | 9.4% |
| n | 5134 | 7.9% |
| o | 5074 | 7.8% |
| l | 3970 | 6.1% |
| r | 3568 | 5.5% |
| i | 3423 | 5.3% |
| 3296 | 5.1% | |
| s | 2853 | 4.4% |
| t | 2602 | 4.0% |
| Other values (42) | 21843 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 51185 | |
| Uppercase Letter | 10339 | 16.0% |
| Space Separator | 3296 | 5.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 6946 | |
| e | 6111 | |
| n | 5134 | |
| o | 5074 | |
| l | 3970 | |
| r | 3568 | 7.0% |
| i | 3423 | 6.7% |
| s | 2853 | 5.6% |
| t | 2602 | 5.1% |
| d | 1669 | 3.3% |
| Other values (16) | 9835 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1576 | |
| C | 977 | 9.4% |
| L | 869 | 8.4% |
| B | 731 | 7.1% |
| A | 651 | 6.3% |
| M | 599 | 5.8% |
| P | 582 | 5.6% |
| D | 533 | 5.2% |
| F | 471 | 4.6% |
| R | 447 | 4.3% |
| Other values (15) | 2903 |
Space Separator
| Value | Count | Frequency (%) |
| 3296 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 61524 | |
| Common | 3296 | 5.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 6946 | 11.3% |
| e | 6111 | 9.9% |
| n | 5134 | 8.3% |
| o | 5074 | 8.2% |
| l | 3970 | 6.5% |
| r | 3568 | 5.8% |
| i | 3423 | 5.6% |
| s | 2853 | 4.6% |
| t | 2602 | 4.2% |
| d | 1669 | 2.7% |
| Other values (41) | 20174 |
Common
| Value | Count | Frequency (%) |
| 3296 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 64820 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 6946 | 10.7% |
| e | 6111 | 9.4% |
| n | 5134 | 7.9% |
| o | 5074 | 7.8% |
| l | 3970 | 6.1% |
| r | 3568 | 5.5% |
| i | 3423 | 5.3% |
| 3296 | 5.1% | |
| s | 2853 | 4.4% |
| t | 2602 | 4.0% |
| Other values (42) | 21843 |
| Distinct | 1626 |
|---|---|
| Distinct (%) | 23.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 93486.07057 |
| Minimum | 90001 |
|---|---|
| Maximum | 96150 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 90001 |
|---|---|
| 5-th percentile | 90241.1 |
| Q1 | 92101 |
| median | 93518 |
| Q3 | 95329 |
| 95-th percentile | 96020.9 |
| Maximum | 96150 |
| Range | 6149 |
| Interquartile range (IQR) | 3228 |
Descriptive statistics
| Standard deviation | 1856.767505 |
|---|---|
| Coefficient of variation (CV) | 0.01986143491 |
| Kurtosis | -1.173915431 |
| Mean | 93486.07057 |
| Median Absolute Deviation (MAD) | 1605 |
| Skewness | -0.2096151191 |
| Sum | 658422395 |
| Variance | 3447585.568 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 92028 | 43 | 0.6% |
| 92027 | 38 | 0.5% |
| 92122 | 36 | 0.5% |
| 92117 | 34 | 0.5% |
| 92126 | 32 | 0.5% |
| 92592 | 30 | 0.4% |
| 92109 | 27 | 0.4% |
| 92130 | 22 | 0.3% |
| 92121 | 20 | 0.3% |
| 92129 | 16 | 0.2% |
| Other values (1616) | 6745 |
| Value | Count | Frequency (%) |
| 90001 | 4 | |
| 90002 | 4 | |
| 90003 | 5 | |
| 90004 | 5 | |
| 90005 | 4 | |
| 90006 | 5 | |
| 90007 | 5 | |
| 90008 | 5 | |
| 90010 | 4 | |
| 90011 | 5 |
| Value | Count | Frequency (%) |
| 96150 | 2 | |
| 96148 | 4 | |
| 96146 | 4 | |
| 96145 | 3 | |
| 96143 | 4 | |
| 96142 | 3 | |
| 96141 | 3 | |
| 96140 | 4 | |
| 96137 | 4 | |
| 96136 | 4 |
| Distinct | 1626 |
|---|---|
| Distinct (%) | 23.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.19745482 |
| Minimum | 32.555828 |
|---|---|
| Maximum | 41.962127 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 32.555828 |
|---|---|
| 5-th percentile | 32.886925 |
| Q1 | 33.990646 |
| median | 36.205465 |
| Q3 | 38.161321 |
| 95-th percentile | 40.4974252 |
| Maximum | 41.962127 |
| Range | 9.406299 |
| Interquartile range (IQR) | 4.170675 |
Descriptive statistics
| Standard deviation | 2.468928682 |
|---|---|
| Coefficient of variation (CV) | 0.06820724534 |
| Kurtosis | -1.160506077 |
| Mean | 36.19745482 |
| Median Absolute Deviation (MAD) | 2.169863 |
| Skewness | 0.3148042686 |
| Sum | 254938.6743 |
| Variance | 6.095608835 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33.362575 | 43 | 0.6% |
| 33.141265 | 38 | 0.5% |
| 32.85723 | 36 | 0.5% |
| 32.825086 | 34 | 0.5% |
| 32.886925 | 32 | 0.5% |
| 33.507255 | 30 | 0.4% |
| 32.787836 | 27 | 0.4% |
| 32.957195 | 22 | 0.3% |
| 32.898613 | 20 | 0.3% |
| 32.961064 | 16 | 0.2% |
| Other values (1616) | 6745 |
| Value | Count | Frequency (%) |
| 32.555828 | 5 | |
| 32.578103 | 4 | |
| 32.579134 | 4 | |
| 32.587557 | 5 | |
| 32.605012 | 4 | |
| 32.607964 | 5 | |
| 32.619465 | 5 | |
| 32.622999 | 4 | |
| 32.636792 | 4 | |
| 32.64164 | 5 |
| Value | Count | Frequency (%) |
| 41.962127 | 4 | |
| 41.950683 | 4 | |
| 41.949216 | 4 | |
| 41.932207 | 3 | |
| 41.924174 | 3 | |
| 41.867908 | 4 | |
| 41.831901 | 4 | |
| 41.816595 | 4 | |
| 41.813521 | 4 | |
| 41.769709 | 4 |
| Distinct | 1625 |
|---|---|
| Distinct (%) | 23.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -119.7566837 |
| Minimum | -124.301372 |
|---|---|
| Maximum | -114.192901 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 7043 |
| Negative (%) | 100.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | -124.301372 |
|---|---|
| 5-th percentile | -122.9755 |
| Q1 | -121.78809 |
| median | -119.595293 |
| Q3 | -117.969795 |
| 95-th percentile | -116.873258 |
| Maximum | -114.192901 |
| Range | 10.108471 |
| Interquartile range (IQR) | 3.818295 |
Descriptive statistics
| Standard deviation | 2.154425092 |
|---|---|
| Coefficient of variation (CV) | -0.01799001965 |
| Kurtosis | -1.191290554 |
| Mean | -119.7566837 |
| Median Absolute Deviation (MAD) | 1.848851 |
| Skewness | -0.09193163502 |
| Sum | -843446.3231 |
| Variance | 4.641547478 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -117.299644 | 43 | 0.6% |
| -116.967221 | 38 | 0.5% |
| -117.209774 | 36 | 0.5% |
| -117.199424 | 34 | 0.5% |
| -117.152162 | 32 | 0.5% |
| -117.029473 | 30 | 0.4% |
| -117.232376 | 27 | 0.4% |
| -117.202542 | 22 | 0.3% |
| -117.202937 | 20 | 0.3% |
| -117.134917 | 16 | 0.2% |
| Other values (1615) | 6745 |
| Value | Count | Frequency (%) |
| -124.301372 | 4 | |
| -124.240051 | 4 | |
| -124.217378 | 4 | |
| -124.210902 | 4 | |
| -124.189977 | 4 | |
| -124.163234 | 4 | |
| -124.15428 | 4 | |
| -124.121504 | 4 | |
| -124.108897 | 4 | |
| -124.098739 | 4 |
| Value | Count | Frequency (%) |
| -114.192901 | 4 | |
| -114.36514 | 5 | |
| -114.702256 | 4 | |
| -114.71612 | 4 | |
| -114.758334 | 5 | |
| -114.850784 | 4 | |
| -115.152865 | 2 | < 0.1% |
| -115.191857 | 5 | |
| -115.257009 | 5 | |
| -115.287901 | 4 |
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.951867102 |
| Minimum | 0 |
|---|---|
| Maximum | 11 |
| Zeros | 3821 |
| Zeros (%) | 54.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3 |
| 95-th percentile | 9 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 3.0011993 |
|---|---|
| Coefficient of variation (CV) | 1.537604326 |
| Kurtosis | 0.7219639341 |
| Mean | 1.951867102 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.446059625 |
| Sum | 13747 |
| Variance | 9.007197238 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3821 | |
| 1 | 1086 | 15.4% |
| 5 | 264 | 3.7% |
| 3 | 255 | 3.6% |
| 7 | 248 | 3.5% |
| 9 | 238 | 3.4% |
| 2 | 236 | 3.4% |
| 4 | 236 | 3.4% |
| 10 | 223 | 3.2% |
| 6 | 221 | 3.1% |
| Other values (2) | 215 | 3.1% |
| Value | Count | Frequency (%) |
| 0 | 3821 | |
| 1 | 1086 | 15.4% |
| 2 | 236 | 3.4% |
| 3 | 255 | 3.6% |
| 4 | 236 | 3.4% |
| 5 | 264 | 3.7% |
| 6 | 221 | 3.1% |
| 7 | 248 | 3.5% |
| 8 | 213 | 3.0% |
| 9 | 238 | 3.4% |
| Value | Count | Frequency (%) |
| 11 | 2 | < 0.1% |
| 10 | 223 | |
| 9 | 238 | |
| 8 | 213 | |
| 7 | 248 | |
| 6 | 221 | |
| 5 | 264 | |
| 4 | 236 | |
| 3 | 255 | |
| 2 | 236 |
| Distinct | 72 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.386767 |
| Minimum | 1 |
|---|---|
| Maximum | 72 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 9 |
| median | 29 |
| Q3 | 55 |
| 95-th percentile | 72 |
| Maximum | 72 |
| Range | 71 |
| Interquartile range (IQR) | 46 |
Descriptive statistics
| Standard deviation | 24.54206101 |
|---|---|
| Coefficient of variation (CV) | 0.757780516 |
| Kurtosis | -1.387052361 |
| Mean | 32.386767 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | 0.2405426141 |
| Sum | 228100 |
| Variance | 602.3127587 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 613 | 8.7% |
| 72 | 362 | 5.1% |
| 2 | 238 | 3.4% |
| 3 | 200 | 2.8% |
| 4 | 176 | 2.5% |
| 71 | 170 | 2.4% |
| 5 | 133 | 1.9% |
| 7 | 131 | 1.9% |
| 10 | 127 | 1.8% |
| 8 | 123 | 1.7% |
| Other values (62) | 4770 |
| Value | Count | Frequency (%) |
| 1 | 613 | |
| 2 | 238 | 3.4% |
| 3 | 200 | 2.8% |
| 4 | 176 | 2.5% |
| 5 | 133 | 1.9% |
| 6 | 110 | 1.6% |
| 7 | 131 | 1.9% |
| 8 | 123 | 1.7% |
| 9 | 119 | 1.7% |
| 10 | 127 | 1.8% |
| Value | Count | Frequency (%) |
| 72 | 362 | |
| 71 | 170 | |
| 70 | 119 | 1.7% |
| 69 | 95 | 1.3% |
| 68 | 100 | 1.4% |
| 67 | 98 | 1.4% |
| 66 | 89 | 1.3% |
| 65 | 76 | 1.1% |
| 64 | 80 | 1.1% |
| 63 | 72 | 1.0% |
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.1 KiB |
| None | |
|---|---|
| Offer B | |
| Offer E | |
| Offer D | |
| Offer A |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 5.348573051 |
| Min length | 4 |
Characters and Unicode
| Total characters | 37670 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | None |
|---|---|
| 2nd row | None |
| 3rd row | Offer E |
| 4th row | Offer D |
| 5th row | None |
Common Values
| Value | Count | Frequency (%) |
| None | 3877 | |
| Offer B | 824 | 11.7% |
| Offer E | 805 | 11.4% |
| Offer D | 602 | 8.5% |
| Offer A | 520 | 7.4% |
| Offer C | 415 | 5.9% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| none | 3877 | |
| offer | 3166 | |
| b | 824 | 8.1% |
| e | 805 | 7.9% |
| d | 602 | 5.9% |
| a | 520 | 5.1% |
| c | 415 | 4.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 7043 | |
| f | 6332 | |
| N | 3877 | |
| o | 3877 | |
| n | 3877 | |
| O | 3166 | |
| r | 3166 | |
| 3166 | ||
| B | 824 | 2.2% |
| E | 805 | 2.1% |
| Other values (3) | 1537 | 4.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 24295 | |
| Uppercase Letter | 10209 | |
| Space Separator | 3166 | 8.4% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 3877 | |
| O | 3166 | |
| B | 824 | 8.1% |
| E | 805 | 7.9% |
| D | 602 | 5.9% |
| A | 520 | 5.1% |
| C | 415 | 4.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 7043 | |
| f | 6332 | |
| o | 3877 | |
| n | 3877 | |
| r | 3166 |
Space Separator
| Value | Count | Frequency (%) |
| 3166 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 34504 | |
| Common | 3166 | 8.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 7043 | |
| f | 6332 | |
| N | 3877 | |
| o | 3877 | |
| n | 3877 | |
| O | 3166 | |
| r | 3166 | |
| B | 824 | 2.4% |
| E | 805 | 2.3% |
| D | 602 | 1.7% |
| Other values (2) | 935 | 2.7% |
Common
| Value | Count | Frequency (%) |
| 3166 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 37670 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 7043 | |
| f | 6332 | |
| N | 3877 | |
| o | 3877 | |
| n | 3877 | |
| O | 3166 | |
| r | 3166 | |
| 3166 | ||
| B | 824 | 2.2% |
| E | 805 | 2.1% |
| Other values (3) | 1537 | 4.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.0 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 6361 | |
| False | 682 | 9.7% |
| Distinct | 3583 |
|---|---|
| Distinct (%) | 56.3% |
| Missing | 682 |
| Missing (%) | 9.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.42051721 |
| Minimum | 1.01 |
|---|---|
| Maximum | 49.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 1.01 |
|---|---|
| 5-th percentile | 3.27 |
| Q1 | 13.05 |
| median | 25.69 |
| Q3 | 37.68 |
| 95-th percentile | 47.64 |
| Maximum | 49.99 |
| Range | 48.98 |
| Interquartile range (IQR) | 24.63 |
Descriptive statistics
| Standard deviation | 14.20037358 |
|---|---|
| Coefficient of variation (CV) | 0.5586185938 |
| Kurtosis | -1.20599849 |
| Mean | 25.42051721 |
| Median Absolute Deviation (MAD) | 12.29 |
| Skewness | -0.001970967867 |
| Sum | 161699.91 |
| Variance | 201.6506098 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 18.26 | 7 | 0.1% |
| 30.07 | 6 | 0.1% |
| 45.92 | 6 | 0.1% |
| 30.09 | 6 | 0.1% |
| 42.55 | 6 | 0.1% |
| 49.51 | 6 | 0.1% |
| 22.56 | 6 | 0.1% |
| 22.83 | 6 | 0.1% |
| 41.93 | 6 | 0.1% |
| 18.42 | 6 | 0.1% |
| Other values (3573) | 6300 | |
| (Missing) | 682 | 9.7% |
| Value | Count | Frequency (%) |
| 1.01 | 1 | < 0.1% |
| 1.02 | 3 | |
| 1.03 | 1 | < 0.1% |
| 1.05 | 1 | < 0.1% |
| 1.06 | 1 | < 0.1% |
| 1.07 | 1 | < 0.1% |
| 1.08 | 2 | |
| 1.09 | 2 | |
| 1.1 | 1 | < 0.1% |
| 1.12 | 3 |
| Value | Count | Frequency (%) |
| 49.99 | 1 | < 0.1% |
| 49.98 | 3 | |
| 49.96 | 2 | |
| 49.95 | 2 | |
| 49.94 | 1 | < 0.1% |
| 49.92 | 1 | < 0.1% |
| 49.91 | 3 | |
| 49.9 | 3 | |
| 49.88 | 1 | < 0.1% |
| 49.87 | 1 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 682 |
| Missing (%) | 9.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3390 | |
| True | 2971 | |
| (Missing) | 682 | 9.7% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.0 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 5517 | |
| False | 1526 | 21.7% |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 55.1 KiB |
| Fiber Optic | |
|---|---|
| DSL | |
| Cable |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 7.701830705 |
| Min length | 3 |
Characters and Unicode
| Total characters | 42491 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cable |
|---|---|
| 2nd row | Cable |
| 3rd row | Fiber Optic |
| 4th row | Fiber Optic |
| 5th row | Fiber Optic |
Common Values
| Value | Count | Frequency (%) |
| Fiber Optic | 3035 | |
| DSL | 1652 | |
| Cable | 830 | 11.8% |
| (Missing) | 1526 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| fiber | 3035 | |
| optic | 3035 | |
| dsl | 1652 | |
| cable | 830 | 9.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 6070 | |
| b | 3865 | |
| e | 3865 | |
| F | 3035 | |
| r | 3035 | |
| 3035 | ||
| O | 3035 | |
| p | 3035 | |
| t | 3035 | |
| c | 3035 | |
| Other values (6) | 7446 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 27600 | |
| Uppercase Letter | 11856 | |
| Space Separator | 3035 | 7.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 6070 | |
| b | 3865 | |
| e | 3865 | |
| r | 3035 | |
| p | 3035 | |
| t | 3035 | |
| c | 3035 | |
| a | 830 | 3.0% |
| l | 830 | 3.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 3035 | |
| O | 3035 | |
| D | 1652 | |
| S | 1652 | |
| L | 1652 | |
| C | 830 | 7.0% |
Space Separator
| Value | Count | Frequency (%) |
| 3035 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 39456 | |
| Common | 3035 | 7.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 6070 | |
| b | 3865 | |
| e | 3865 | |
| F | 3035 | |
| r | 3035 | |
| O | 3035 | |
| p | 3035 | |
| t | 3035 | |
| c | 3035 | |
| D | 1652 | 4.2% |
| Other values (5) | 5794 |
Common
| Value | Count | Frequency (%) |
| 3035 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 42491 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 6070 | |
| b | 3865 | |
| e | 3865 | |
| F | 3035 | |
| r | 3035 | |
| 3035 | ||
| O | 3035 | |
| p | 3035 | |
| t | 3035 | |
| c | 3035 | |
| Other values (6) | 7446 |
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.18995831 |
| Minimum | 2 |
|---|---|
| Maximum | 85 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 13 |
| median | 21 |
| Q3 | 30 |
| 95-th percentile | 71 |
| Maximum | 85 |
| Range | 83 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 19.58658527 |
|---|---|
| Coefficient of variation (CV) | 0.7478662257 |
| Kurtosis | 0.6368415438 |
| Mean | 26.18995831 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 1.184055978 |
| Sum | 144490 |
| Variance | 383.6343226 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 19 | 220 | 3.1% |
| 27 | 199 | 2.8% |
| 30 | 193 | 2.7% |
| 59 | 192 | 2.7% |
| 26 | 191 | 2.7% |
| 23 | 179 | 2.5% |
| 22 | 172 | 2.4% |
| 21 | 171 | 2.4% |
| 18 | 164 | 2.3% |
| 13 | 164 | 2.3% |
| Other values (39) | 3672 | |
| (Missing) | 1526 |
| Value | Count | Frequency (%) |
| 2 | 116 | |
| 3 | 130 | |
| 4 | 129 | |
| 5 | 114 | |
| 6 | 114 | |
| 7 | 116 | |
| 8 | 120 | |
| 9 | 116 | |
| 10 | 132 | |
| 11 | 145 |
| Value | Count | Frequency (%) |
| 85 | 48 | 0.7% |
| 82 | 43 | 0.6% |
| 76 | 58 | 0.8% |
| 75 | 15 | 0.2% |
| 73 | 81 | |
| 71 | 42 | 0.6% |
| 69 | 75 | 1.1% |
| 59 | 192 | |
| 58 | 45 | 0.6% |
| 57 | 34 | 0.5% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3498 | |
| True | 2019 | |
| (Missing) | 1526 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3088 | |
| True | 2429 | |
| (Missing) | 1526 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3095 | |
| True | 2422 | |
| (Missing) | 1526 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3473 | |
| True | 2044 | |
| (Missing) | 1526 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 2810 | |
| True | 2707 | |
| (Missing) | 1526 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 2785 | |
| True | 2732 | |
| (Missing) | 1526 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3029 | |
| True | 2488 | |
| (Missing) | 1526 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1526 |
| Missing (%) | 21.7% |
| Memory size | 13.9 KiB |
| True | |
|---|---|
| False | |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 4745 | |
| False | 772 | 11.0% |
| (Missing) | 1526 | 21.7% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.1 KiB |
| Month-to-Month | |
|---|---|
| Two Year | |
| One Year |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 11.07539401 |
| Min length | 8 |
Characters and Unicode
| Total characters | 78004 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | One Year |
|---|---|
| 2nd row | Month-to-Month |
| 3rd row | Month-to-Month |
| 4th row | Month-to-Month |
| 5th row | Month-to-Month |
Common Values
| Value | Count | Frequency (%) |
| Month-to-Month | 3610 | |
| Two Year | 1883 | |
| One Year | 1550 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| month-to-month | 3610 | |
| year | 3433 | |
| two | 1883 | |
| one | 1550 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 12713 | |
| t | 10830 | |
| n | 8770 | |
| M | 7220 | |
| h | 7220 | |
| - | 7220 | |
| e | 4983 | 6.4% |
| 3433 | 4.4% | |
| Y | 3433 | 4.4% |
| a | 3433 | 4.4% |
| Other values (4) | 8749 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 53265 | |
| Uppercase Letter | 14086 | 18.1% |
| Dash Punctuation | 7220 | 9.3% |
| Space Separator | 3433 | 4.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 12713 | |
| t | 10830 | |
| n | 8770 | |
| h | 7220 | |
| e | 4983 | 9.4% |
| a | 3433 | 6.4% |
| r | 3433 | 6.4% |
| w | 1883 | 3.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 7220 | |
| Y | 3433 | |
| T | 1883 | 13.4% |
| O | 1550 | 11.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 7220 |
Space Separator
| Value | Count | Frequency (%) |
| 3433 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 67351 | |
| Common | 10653 | 13.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 12713 | |
| t | 10830 | |
| n | 8770 | |
| M | 7220 | |
| h | 7220 | |
| e | 4983 | 7.4% |
| Y | 3433 | 5.1% |
| a | 3433 | 5.1% |
| r | 3433 | 5.1% |
| T | 1883 | 2.8% |
| Other values (2) | 3433 | 5.1% |
Common
| Value | Count | Frequency (%) |
| - | 7220 | |
| 3433 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 78004 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 12713 | |
| t | 10830 | |
| n | 8770 | |
| M | 7220 | |
| h | 7220 | |
| - | 7220 | |
| e | 4983 | 6.4% |
| 3433 | 4.4% | |
| Y | 3433 | 4.4% |
| a | 3433 | 4.4% |
| Other values (4) | 8749 |
Paperless Billing
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.0 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 4171 | |
| False | 2872 |
Payment Method
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.1 KiB |
| Bank Withdrawal | |
|---|---|
| Credit Card | |
| Mailed Check | 385 |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 13.27474088 |
| Min length | 11 |
Characters and Unicode
| Total characters | 93494 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Credit Card |
|---|---|
| 2nd row | Credit Card |
| 3rd row | Bank Withdrawal |
| 4th row | Bank Withdrawal |
| 5th row | Credit Card |
Common Values
| Value | Count | Frequency (%) |
| Bank Withdrawal | 3909 | |
| Credit Card | 2749 | |
| Mailed Check | 385 | 5.5% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| bank | 3909 | |
| withdrawal | 3909 | |
| credit | 2749 | |
| card | 2749 | |
| mailed | 385 | 2.7% |
| check | 385 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 14861 | |
| d | 9792 | |
| r | 9407 | |
| 7043 | 7.5% | |
| i | 7043 | 7.5% |
| t | 6658 | 7.1% |
| C | 5883 | 6.3% |
| h | 4294 | 4.6% |
| k | 4294 | 4.6% |
| l | 4294 | 4.6% |
| Other values (7) | 19925 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 72365 | |
| Uppercase Letter | 14086 | 15.1% |
| Space Separator | 7043 | 7.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 14861 | |
| d | 9792 | |
| r | 9407 | |
| i | 7043 | |
| t | 6658 | |
| h | 4294 | 5.9% |
| k | 4294 | 5.9% |
| l | 4294 | 5.9% |
| w | 3909 | 5.4% |
| n | 3909 | 5.4% |
| Other values (2) | 3904 | 5.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 5883 | |
| B | 3909 | |
| W | 3909 | |
| M | 385 | 2.7% |
Space Separator
| Value | Count | Frequency (%) |
| 7043 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 86451 | |
| Common | 7043 | 7.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 14861 | |
| d | 9792 | |
| r | 9407 | |
| i | 7043 | |
| t | 6658 | |
| C | 5883 | 6.8% |
| h | 4294 | 5.0% |
| k | 4294 | 5.0% |
| l | 4294 | 5.0% |
| w | 3909 | 4.5% |
| Other values (6) | 16016 |
Common
| Value | Count | Frequency (%) |
| 7043 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 93494 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 14861 | |
| d | 9792 | |
| r | 9407 | |
| 7043 | 7.5% | |
| i | 7043 | 7.5% |
| t | 6658 | 7.1% |
| C | 5883 | 6.3% |
| h | 4294 | 4.6% |
| k | 4294 | 4.6% |
| l | 4294 | 4.6% |
| Other values (7) | 19925 |
| Distinct | 1591 |
|---|---|
| Distinct (%) | 22.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 63.59613091 |
| Minimum | -10 |
|---|---|
| Maximum | 118.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 120 |
| Negative (%) | 1.7% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | -10 |
|---|---|
| 5-th percentile | 19.5 |
| Q1 | 30.4 |
| median | 70.05 |
| Q3 | 89.75 |
| 95-th percentile | 107.195 |
| Maximum | 118.75 |
| Range | 128.75 |
| Interquartile range (IQR) | 59.35 |
Descriptive statistics
| Standard deviation | 31.20474312 |
|---|---|
| Coefficient of variation (CV) | 0.4906704648 |
| Kurtosis | -1.125789607 |
| Mean | 63.59613091 |
| Median Absolute Deviation (MAD) | 24.5 |
| Skewness | -0.2753938343 |
| Sum | 447907.55 |
| Variance | 973.7359929 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20.05 | 60 | 0.9% |
| 19.85 | 45 | 0.6% |
| 19.95 | 44 | 0.6% |
| 19.9 | 44 | 0.6% |
| 20 | 43 | 0.6% |
| 19.65 | 42 | 0.6% |
| 19.7 | 40 | 0.6% |
| 20.25 | 39 | 0.6% |
| 20.15 | 39 | 0.6% |
| 19.55 | 39 | 0.6% |
| Other values (1581) | 6608 |
| Value | Count | Frequency (%) |
| -10 | 13 | |
| -9 | 9 | |
| -8 | 12 | |
| -7 | 16 | |
| -6 | 6 | 0.1% |
| -5 | 11 | |
| -4 | 17 | |
| -3 | 13 | |
| -2 | 10 | |
| -1 | 13 |
| Value | Count | Frequency (%) |
| 118.75 | 1 | |
| 118.65 | 1 | |
| 118.6 | 2 | |
| 118.35 | 1 | |
| 118.2 | 1 | |
| 117.8 | 1 | |
| 117.6 | 1 | |
| 117.5 | 1 | |
| 117.45 | 1 | |
| 117.35 | 1 |
| Distinct | 6540 |
|---|---|
| Distinct (%) | 92.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2280.381264 |
| Minimum | 18.8 |
|---|---|
| Maximum | 8684.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 18.8 |
|---|---|
| 5-th percentile | 49.65 |
| Q1 | 400.15 |
| median | 1394.55 |
| Q3 | 3786.6 |
| 95-th percentile | 6921.025 |
| Maximum | 8684.8 |
| Range | 8666 |
| Interquartile range (IQR) | 3386.45 |
Descriptive statistics
| Standard deviation | 2266.220462 |
|---|---|
| Coefficient of variation (CV) | 0.9937901605 |
| Kurtosis | -0.2276926647 |
| Mean | 2280.381264 |
| Median Absolute Deviation (MAD) | 1219.75 |
| Skewness | 0.9637910861 |
| Sum | 16060725.24 |
| Variance | 5135755.182 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20.2 | 11 | 0.2% |
| 19.75 | 9 | 0.1% |
| 19.9 | 8 | 0.1% |
| 20.05 | 8 | 0.1% |
| 19.65 | 8 | 0.1% |
| 19.55 | 7 | 0.1% |
| 45.3 | 7 | 0.1% |
| 20.15 | 6 | 0.1% |
| 19.45 | 6 | 0.1% |
| 20.25 | 6 | 0.1% |
| Other values (6530) | 6967 |
| Value | Count | Frequency (%) |
| 18.8 | 1 | < 0.1% |
| 18.85 | 2 | |
| 18.9 | 1 | < 0.1% |
| 19 | 1 | < 0.1% |
| 19.05 | 1 | < 0.1% |
| 19.1 | 3 | |
| 19.15 | 1 | < 0.1% |
| 19.2 | 4 | |
| 19.25 | 3 | |
| 19.3 | 4 |
| Value | Count | Frequency (%) |
| 8684.8 | 1 | |
| 8672.45 | 1 | |
| 8670.1 | 1 | |
| 8594.4 | 1 | |
| 8564.75 | 1 | |
| 8547.15 | 1 | |
| 8543.25 | 1 | |
| 8529.5 | 1 | |
| 8496.7 | 1 | |
| 8477.7 | 1 |
| Distinct | 500 |
|---|---|
| Distinct (%) | 7.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.962182309 |
| Minimum | 0 |
|---|---|
| Maximum | 49.79 |
| Zeros | 6518 |
| Zeros (%) | 92.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 18.149 |
| Maximum | 49.79 |
| Range | 49.79 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 7.902614384 |
|---|---|
| Coefficient of variation (CV) | 4.027461847 |
| Kurtosis | 18.35065824 |
| Mean | 1.962182309 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.328516701 |
| Sum | 13819.65 |
| Variance | 62.45131411 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6518 | |
| 16.56 | 2 | < 0.1% |
| 8.74 | 2 | < 0.1% |
| 1.31 | 2 | < 0.1% |
| 41.74 | 2 | < 0.1% |
| 25.67 | 2 | < 0.1% |
| 29.76 | 2 | < 0.1% |
| 18.55 | 2 | < 0.1% |
| 15.41 | 2 | < 0.1% |
| 27.6 | 2 | < 0.1% |
| Other values (490) | 507 | 7.2% |
| Value | Count | Frequency (%) |
| 0 | 6518 | |
| 1.01 | 1 | < 0.1% |
| 1.09 | 1 | < 0.1% |
| 1.27 | 1 | < 0.1% |
| 1.31 | 2 | < 0.1% |
| 1.48 | 1 | < 0.1% |
| 1.65 | 1 | < 0.1% |
| 1.66 | 1 | < 0.1% |
| 1.69 | 1 | < 0.1% |
| 1.83 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 49.79 | 1 | |
| 49.76 | 1 | |
| 49.57 | 2 | |
| 49.53 | 1 | |
| 49.51 | 1 | |
| 49.38 | 1 | |
| 49.37 | 1 | |
| 49.24 | 1 | |
| 49.23 | 1 | |
| 49.22 | 1 |
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.860712764 |
| Minimum | 0 |
|---|---|
| Maximum | 150 |
| Zeros | 6315 |
| Zeros (%) | 89.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 60 |
| Maximum | 150 |
| Range | 150 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 25.104978 |
|---|---|
| Coefficient of variation (CV) | 3.659237584 |
| Kurtosis | 16.45887408 |
| Mean | 6.860712764 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.091209239 |
| Sum | 48320 |
| Variance | 630.2599204 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6315 | |
| 10 | 138 | 2.0% |
| 40 | 62 | 0.9% |
| 30 | 58 | 0.8% |
| 20 | 51 | 0.7% |
| 80 | 47 | 0.7% |
| 100 | 44 | 0.6% |
| 50 | 43 | 0.6% |
| 150 | 42 | 0.6% |
| 130 | 40 | 0.6% |
| Other values (6) | 203 | 2.9% |
| Value | Count | Frequency (%) |
| 0 | 6315 | |
| 10 | 138 | 2.0% |
| 20 | 51 | 0.7% |
| 30 | 58 | 0.8% |
| 40 | 62 | 0.9% |
| 50 | 43 | 0.6% |
| 60 | 36 | 0.5% |
| 70 | 34 | 0.5% |
| 80 | 47 | 0.7% |
| 90 | 35 | 0.5% |
| Value | Count | Frequency (%) |
| 150 | 42 | |
| 140 | 38 | |
| 130 | 40 | |
| 120 | 28 | |
| 110 | 32 | |
| 100 | 44 | |
| 90 | 35 | |
| 80 | 47 | |
| 70 | 34 | |
| 60 | 36 |
| Distinct | 6068 |
|---|---|
| Distinct (%) | 86.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 749.0992617 |
| Minimum | 0 |
|---|---|
| Maximum | 3564.72 |
| Zeros | 682 |
| Zeros (%) | 9.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 70.545 |
| median | 401.44 |
| Q3 | 1191.1 |
| 95-th percentile | 2577.877 |
| Maximum | 3564.72 |
| Range | 3564.72 |
| Interquartile range (IQR) | 1120.555 |
Descriptive statistics
| Standard deviation | 846.6600548 |
|---|---|
| Coefficient of variation (CV) | 1.130237471 |
| Kurtosis | 0.644092077 |
| Mean | 749.0992617 |
| Median Absolute Deviation (MAD) | 382.12 |
| Skewness | 1.238281984 |
| Sum | 5275906.1 |
| Variance | 716833.2484 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 682 | 9.7% |
| 15.6 | 4 | 0.1% |
| 48.96 | 4 | 0.1% |
| 22.86 | 4 | 0.1% |
| 597.6 | 3 | < 0.1% |
| 2077.92 | 3 | < 0.1% |
| 198 | 3 | < 0.1% |
| 15.28 | 3 | < 0.1% |
| 808.08 | 3 | < 0.1% |
| 41.1 | 3 | < 0.1% |
| Other values (6058) | 6331 |
| Value | Count | Frequency (%) |
| 0 | 682 | |
| 1.13 | 1 | < 0.1% |
| 1.15 | 1 | < 0.1% |
| 1.17 | 1 | < 0.1% |
| 1.23 | 1 | < 0.1% |
| 1.28 | 1 | < 0.1% |
| 1.47 | 1 | < 0.1% |
| 1.48 | 1 | < 0.1% |
| 1.5 | 1 | < 0.1% |
| 1.59 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 3564.72 | 1 | |
| 3564 | 1 | |
| 3536.64 | 1 | |
| 3515.92 | 1 | |
| 3508.82 | 1 | |
| 3501.72 | 1 | |
| 3493.44 | 1 | |
| 3492.72 | 1 | |
| 3487.68 | 1 | |
| 3482.64 | 1 |
| Distinct | 6975 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3034.379056 |
| Minimum | 21.36 |
|---|---|
| Maximum | 11979.34 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 55.1 KiB |
Quantile statistics
| Minimum | 21.36 |
|---|---|
| 5-th percentile | 78.452 |
| Q1 | 605.61 |
| median | 2108.64 |
| Q3 | 4801.145 |
| 95-th percentile | 8747.041 |
| Maximum | 11979.34 |
| Range | 11957.98 |
| Interquartile range (IQR) | 4195.535 |
Descriptive statistics
| Standard deviation | 2865.204542 |
|---|---|
| Coefficient of variation (CV) | 0.9442474025 |
| Kurtosis | -0.2034573897 |
| Mean | 3034.379056 |
| Median Absolute Deviation (MAD) | 1767.61 |
| Skewness | 0.919410268 |
| Sum | 21371131.69 |
| Variance | 8209397.065 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24.8 | 3 | < 0.1% |
| 116.27 | 3 | < 0.1% |
| 68.41 | 3 | < 0.1% |
| 66.56 | 3 | < 0.1% |
| 3386.4 | 2 | < 0.1% |
| 174.93 | 2 | < 0.1% |
| 608.85 | 2 | < 0.1% |
| 712.85 | 2 | < 0.1% |
| 3423.5 | 2 | < 0.1% |
| 88.75 | 2 | < 0.1% |
| Other values (6965) | 7019 |
| Value | Count | Frequency (%) |
| 21.36 | 1 | |
| 21.4 | 1 | |
| 21.61 | 1 | |
| 22.08 | 1 | |
| 22.12 | 1 | |
| 22.25 | 1 | |
| 22.28 | 1 | |
| 22.54 | 1 | |
| 23.24 | 2 | |
| 23.28 | 1 |
| Value | Count | Frequency (%) |
| 11979.34 | 1 | |
| 11868.34 | 1 | |
| 11795.78 | 1 | |
| 11688.9 | 1 | |
| 11634.53 | 1 | |
| 11596.99 | 1 | |
| 11564.37 | 1 | |
| 11529.54 | 1 | |
| 11514.81 | 1 | |
| 11501.82 | 1 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 55.1 KiB |
| Stayed | |
|---|---|
| Churned | |
| Joined | 454 |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 6.265369871 |
| Min length | 6 |
Characters and Unicode
| Total characters | 44127 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Stayed |
|---|---|
| 2nd row | Stayed |
| 3rd row | Churned |
| 4th row | Churned |
| 5th row | Churned |
Common Values
| Value | Count | Frequency (%) |
| Stayed | 4720 | |
| Churned | 1869 | 26.5% |
| Joined | 454 | 6.4% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| stayed | 4720 | |
| churned | 1869 | 26.5% |
| joined | 454 | 6.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 7043 | |
| d | 7043 | |
| S | 4720 | |
| t | 4720 | |
| a | 4720 | |
| y | 4720 | |
| n | 2323 | 5.3% |
| C | 1869 | 4.2% |
| h | 1869 | 4.2% |
| u | 1869 | 4.2% |
| Other values (4) | 3231 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 37084 | |
| Uppercase Letter | 7043 | 16.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 7043 | |
| d | 7043 | |
| t | 4720 | |
| a | 4720 | |
| y | 4720 | |
| n | 2323 | 6.3% |
| h | 1869 | 5.0% |
| u | 1869 | 5.0% |
| r | 1869 | 5.0% |
| o | 454 | 1.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 4720 | |
| C | 1869 | 26.5% |
| J | 454 | 6.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 44127 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 7043 | |
| d | 7043 | |
| S | 4720 | |
| t | 4720 | |
| a | 4720 | |
| y | 4720 | |
| n | 2323 | 5.3% |
| C | 1869 | 4.2% |
| h | 1869 | 4.2% |
| u | 1869 | 4.2% |
| Other values (4) | 3231 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 44127 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 7043 | |
| d | 7043 | |
| S | 4720 | |
| t | 4720 | |
| a | 4720 | |
| y | 4720 | |
| n | 2323 | 5.3% |
| C | 1869 | 4.2% |
| h | 1869 | 4.2% |
| u | 1869 | 4.2% |
| Other values (4) | 3231 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 5174 |
| Missing (%) | 73.5% |
| Memory size | 55.1 KiB |
| Competitor | |
|---|---|
| Dissatisfaction | |
| Attitude | |
| Price | |
| Other |
Length
| Max length | 15 |
|---|---|
| Median length | 10 |
| Mean length | 9.471375067 |
| Min length | 5 |
Characters and Unicode
| Total characters | 17702 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Competitor |
|---|---|
| 2nd row | Dissatisfaction |
| 3rd row | Dissatisfaction |
| 4th row | Dissatisfaction |
| 5th row | Competitor |
Common Values
| Value | Count | Frequency (%) |
| Competitor | 841 | 11.9% |
| Dissatisfaction | 321 | 4.6% |
| Attitude | 314 | 4.5% |
| Price | 211 | 3.0% |
| Other | 182 | 2.6% |
| (Missing) | 5174 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| competitor | 841 | |
| dissatisfaction | 321 | 17.2% |
| attitude | 314 | 16.8% |
| price | 211 | 11.3% |
| other | 182 | 9.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 3448 | |
| i | 2329 | |
| o | 2003 | |
| e | 1548 | |
| r | 1234 | 7.0% |
| s | 963 | 5.4% |
| C | 841 | 4.8% |
| m | 841 | 4.8% |
| p | 841 | 4.8% |
| a | 642 | 3.6% |
| Other values (10) | 3012 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 15833 | |
| Uppercase Letter | 1869 | 10.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 3448 | |
| i | 2329 | |
| o | 2003 | |
| e | 1548 | |
| r | 1234 | 7.8% |
| s | 963 | 6.1% |
| m | 841 | 5.3% |
| p | 841 | 5.3% |
| a | 642 | 4.1% |
| c | 532 | 3.4% |
| Other values (5) | 1452 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 841 | |
| D | 321 | 17.2% |
| A | 314 | 16.8% |
| P | 211 | 11.3% |
| O | 182 | 9.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 17702 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 3448 | |
| i | 2329 | |
| o | 2003 | |
| e | 1548 | |
| r | 1234 | 7.0% |
| s | 963 | 5.4% |
| C | 841 | 4.8% |
| m | 841 | 4.8% |
| p | 841 | 4.8% |
| a | 642 | 3.6% |
| Other values (10) | 3012 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17702 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 3448 | |
| i | 2329 | |
| o | 2003 | |
| e | 1548 | |
| r | 1234 | 7.0% |
| s | 963 | 5.4% |
| C | 841 | 4.8% |
| m | 841 | 4.8% |
| p | 841 | 4.8% |
| a | 642 | 3.6% |
| Other values (10) | 3012 |
| Distinct | 20 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 5174 |
| Missing (%) | 73.5% |
| Memory size | 55.1 KiB |
| Competitor had better devices | |
|---|---|
| Competitor made better offer | |
| Attitude of support person | |
| Don't know | |
| Competitor offered more data | |
| Other values (15) |
Length
| Max length | 41 |
|---|---|
| Median length | 32 |
| Mean length | 25.25682183 |
| Min length | 5 |
Characters and Unicode
| Total characters | 47205 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Competitor had better devices |
|---|---|
| 2nd row | Product dissatisfaction |
| 3rd row | Network reliability |
| 4th row | Limited range of services |
| 5th row | Competitor made better offer |
Common Values
| Value | Count | Frequency (%) |
| Competitor had better devices | 313 | 4.4% |
| Competitor made better offer | 311 | 4.4% |
| Attitude of support person | 220 | 3.1% |
| Don't know | 130 | 1.8% |
| Competitor offered more data | 117 | 1.7% |
| Competitor offered higher download speeds | 100 | 1.4% |
| Attitude of service provider | 94 | 1.3% |
| Price too high | 78 | 1.1% |
| Product dissatisfaction | 77 | 1.1% |
| Network reliability | 72 | 1.0% |
| Other values (10) | 357 | 5.1% |
| (Missing) | 5174 |
Length
| Value | Count | Frequency (%) |
| competitor | 841 | 12.6% |
| better | 624 | 9.4% |
| of | 453 | 6.8% |
| attitude | 314 | 4.7% |
| had | 313 | 4.7% |
| devices | 313 | 4.7% |
| made | 311 | 4.7% |
| offer | 311 | 4.7% |
| support | 263 | 4.0% |
| person | 220 | 3.3% |
| Other values (37) | 2694 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 6138 | |
| t | 5212 | |
| 4788 | ||
| o | 4650 | 9.9% |
| r | 3698 | 7.8% |
| i | 2918 | 6.2% |
| d | 2538 | 5.4% |
| s | 1917 | 4.1% |
| p | 1896 | 4.0% |
| a | 1816 | 3.8% |
| Other values (27) | 11634 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 40330 | |
| Space Separator | 4788 | 10.1% |
| Uppercase Letter | 1898 | 4.0% |
| Other Punctuation | 160 | 0.3% |
| Dash Punctuation | 29 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 6138 | |
| t | 5212 | |
| o | 4650 | |
| r | 3698 | |
| i | 2918 | 7.2% |
| d | 2538 | 6.3% |
| s | 1917 | 4.8% |
| p | 1896 | 4.7% |
| a | 1816 | 4.5% |
| f | 1738 | 4.3% |
| Other values (13) | 7809 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 841 | |
| A | 314 | 16.5% |
| P | 198 | 10.4% |
| L | 160 | 8.4% |
| D | 136 | 7.2% |
| N | 72 | 3.8% |
| S | 63 | 3.3% |
| M | 46 | 2.4% |
| E | 39 | 2.1% |
| W | 29 | 1.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 130 | |
| / | 30 | 18.8% |
Space Separator
| Value | Count | Frequency (%) |
| 4788 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 29 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 42228 | |
| Common | 4977 | 10.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 6138 | |
| t | 5212 | |
| o | 4650 | |
| r | 3698 | 8.8% |
| i | 2918 | 6.9% |
| d | 2538 | 6.0% |
| s | 1917 | 4.5% |
| p | 1896 | 4.5% |
| a | 1816 | 4.3% |
| f | 1738 | 4.1% |
| Other values (23) | 9707 |
Common
| Value | Count | Frequency (%) |
| 4788 | ||
| ' | 130 | 2.6% |
| / | 30 | 0.6% |
| - | 29 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 47205 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 6138 | |
| t | 5212 | |
| 4788 | ||
| o | 4650 | 9.9% |
| r | 3698 | 7.8% |
| i | 2918 | 6.2% |
| d | 2538 | 5.4% |
| s | 1917 | 4.1% |
| p | 1896 | 4.0% |
| a | 1816 | 3.8% |
| Other values (27) | 11634 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Customer ID | Gender | Age | Married | Number of Dependents | City | Zip Code | Latitude | Longitude | Number of Referrals | Tenure in Months | Offer | Phone Service | Avg Monthly Long Distance Charges | Multiple Lines | Internet Service | Internet Type | Avg Monthly GB Download | Online Security | Online Backup | Device Protection Plan | Premium Tech Support | Streaming TV | Streaming Movies | Streaming Music | Unlimited Data | Contract | Paperless Billing | Payment Method | Monthly Charge | Total Charges | Total Refunds | Total Extra Data Charges | Total Long Distance Charges | Total Revenue | Customer Status | Churn Category | Churn Reason | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0002-ORFBO | Female | 37 | Yes | 0 | Frazier Park | 93225 | 34.827662 | -118.999073 | 2 | 9 | None | Yes | 42.39 | No | Yes | Cable | 16.0 | No | Yes | No | Yes | Yes | No | No | Yes | One Year | Yes | Credit Card | 65.60 | 593.30 | 0.00 | 0 | 381.51 | 974.81 | Stayed | NaN | NaN |
| 1 | 0003-MKNFE | Male | 46 | No | 0 | Glendale | 91206 | 34.162515 | -118.203869 | 0 | 9 | None | Yes | 10.69 | Yes | Yes | Cable | 10.0 | No | No | No | No | No | Yes | Yes | No | Month-to-Month | No | Credit Card | -4.00 | 542.40 | 38.33 | 10 | 96.21 | 610.28 | Stayed | NaN | NaN |
| 2 | 0004-TLHLJ | Male | 50 | No | 0 | Costa Mesa | 92627 | 33.645672 | -117.922613 | 0 | 4 | Offer E | Yes | 33.65 | No | Yes | Fiber Optic | 30.0 | No | No | Yes | No | No | No | No | Yes | Month-to-Month | Yes | Bank Withdrawal | 73.90 | 280.85 | 0.00 | 0 | 134.60 | 415.45 | Churned | Competitor | Competitor had better devices |
| 3 | 0011-IGKFF | Male | 78 | Yes | 0 | Martinez | 94553 | 38.014457 | -122.115432 | 1 | 13 | Offer D | Yes | 27.82 | No | Yes | Fiber Optic | 4.0 | No | Yes | Yes | No | Yes | Yes | No | Yes | Month-to-Month | Yes | Bank Withdrawal | 98.00 | 1237.85 | 0.00 | 0 | 361.66 | 1599.51 | Churned | Dissatisfaction | Product dissatisfaction |
| 4 | 0013-EXCHZ | Female | 75 | Yes | 0 | Camarillo | 93010 | 34.227846 | -119.079903 | 3 | 3 | None | Yes | 7.38 | No | Yes | Fiber Optic | 11.0 | No | No | No | Yes | Yes | No | No | Yes | Month-to-Month | Yes | Credit Card | 83.90 | 267.40 | 0.00 | 0 | 22.14 | 289.54 | Churned | Dissatisfaction | Network reliability |
| 5 | 0013-MHZWF | Female | 23 | No | 3 | Midpines | 95345 | 37.581496 | -119.972762 | 0 | 9 | Offer E | Yes | 16.77 | No | Yes | Cable | 73.0 | No | No | No | Yes | Yes | Yes | Yes | Yes | Month-to-Month | Yes | Credit Card | 69.40 | 571.45 | 0.00 | 0 | 150.93 | 722.38 | Stayed | NaN | NaN |
| 6 | 0013-SMEOE | Female | 67 | Yes | 0 | Lompoc | 93437 | 34.757477 | -120.550507 | 1 | 71 | Offer A | Yes | 9.96 | No | Yes | Fiber Optic | 14.0 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Two Year | Yes | Bank Withdrawal | 109.70 | 7904.25 | 0.00 | 0 | 707.16 | 8611.41 | Stayed | NaN | NaN |
| 7 | 0014-BMAQU | Male | 52 | Yes | 0 | Napa | 94558 | 38.489789 | -122.270110 | 8 | 63 | Offer B | Yes | 12.96 | Yes | Yes | Fiber Optic | 7.0 | Yes | No | No | Yes | No | No | No | No | Two Year | Yes | Credit Card | 84.65 | 5377.80 | 0.00 | 20 | 816.48 | 6214.28 | Stayed | NaN | NaN |
| 8 | 0015-UOCOJ | Female | 68 | No | 0 | Simi Valley | 93063 | 34.296813 | -118.685703 | 0 | 7 | Offer E | Yes | 10.53 | No | Yes | DSL | 21.0 | Yes | No | No | No | No | No | No | Yes | Two Year | Yes | Bank Withdrawal | 48.20 | 340.35 | 0.00 | 0 | 73.71 | 414.06 | Stayed | NaN | NaN |
| 9 | 0016-QLJIS | Female | 43 | Yes | 1 | Sheridan | 95681 | 38.984756 | -121.345074 | 3 | 65 | None | Yes | 28.46 | Yes | Yes | Cable | 14.0 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Two Year | Yes | Credit Card | 90.45 | 5957.90 | 0.00 | 0 | 1849.90 | 7807.80 | Stayed | NaN | NaN |
Last rows
| Customer ID | Gender | Age | Married | Number of Dependents | City | Zip Code | Latitude | Longitude | Number of Referrals | Tenure in Months | Offer | Phone Service | Avg Monthly Long Distance Charges | Multiple Lines | Internet Service | Internet Type | Avg Monthly GB Download | Online Security | Online Backup | Device Protection Plan | Premium Tech Support | Streaming TV | Streaming Movies | Streaming Music | Unlimited Data | Contract | Paperless Billing | Payment Method | Monthly Charge | Total Charges | Total Refunds | Total Extra Data Charges | Total Long Distance Charges | Total Revenue | Customer Status | Churn Category | Churn Reason | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7033 | 9975-SKRNR | Male | 24 | No | 0 | Sierraville | 96126 | 39.559709 | -120.345639 | 0 | 1 | Offer E | Yes | 49.51 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Month-to-Month | No | Credit Card | 18.90 | 18.90 | 0.0 | 0 | 49.51 | 68.41 | Joined | NaN | NaN |
| 7034 | 9978-HYCIN | Male | 72 | Yes | 1 | Bakersfield | 93301 | 35.383937 | -119.020428 | 1 | 47 | None | Yes | 42.29 | No | Yes | Fiber Optic | 22.0 | No | Yes | No | No | Yes | No | No | No | One Year | Yes | Bank Withdrawal | 84.95 | 4018.05 | 0.0 | 80 | 1987.63 | 6085.68 | Stayed | NaN | NaN |
| 7035 | 9979-RGMZT | Female | 20 | No | 0 | Los Angeles | 90022 | 34.023810 | -118.156582 | 0 | 7 | Offer E | Yes | 36.49 | No | Yes | Fiber Optic | 42.0 | No | Yes | No | No | Yes | Yes | Yes | Yes | One Year | Yes | Credit Card | 94.05 | 633.45 | 0.0 | 0 | 255.43 | 888.88 | Stayed | NaN | NaN |
| 7036 | 9985-MWVIX | Female | 53 | No | 0 | Hume | 93628 | 36.807595 | -118.901544 | 0 | 1 | Offer E | Yes | 42.09 | No | Yes | Fiber Optic | 9.0 | No | No | No | No | No | No | No | Yes | Month-to-Month | Yes | Credit Card | 70.15 | 70.15 | 0.0 | 0 | 42.09 | 112.24 | Churned | Competitor | Competitor had better devices |
| 7037 | 9986-BONCE | Female | 36 | No | 0 | Fallbrook | 92028 | 33.362575 | -117.299644 | 0 | 4 | None | Yes | 2.01 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Month-to-Month | No | Bank Withdrawal | 20.95 | 85.50 | 0.0 | 0 | 8.04 | 93.54 | Churned | Competitor | Competitor made better offer |
| 7038 | 9987-LUTYD | Female | 20 | No | 0 | La Mesa | 91941 | 32.759327 | -116.997260 | 0 | 13 | Offer D | Yes | 46.68 | No | Yes | DSL | 59.0 | Yes | No | No | Yes | No | No | Yes | Yes | One Year | No | Credit Card | 55.15 | 742.90 | 0.0 | 0 | 606.84 | 1349.74 | Stayed | NaN | NaN |
| 7039 | 9992-RRAMN | Male | 40 | Yes | 0 | Riverbank | 95367 | 37.734971 | -120.954271 | 1 | 22 | Offer D | Yes | 16.20 | Yes | Yes | Fiber Optic | 17.0 | No | No | No | No | No | Yes | Yes | Yes | Month-to-Month | Yes | Bank Withdrawal | 85.10 | 1873.70 | 0.0 | 0 | 356.40 | 2230.10 | Churned | Dissatisfaction | Product dissatisfaction |
| 7040 | 9992-UJOEL | Male | 22 | No | 0 | Elk | 95432 | 39.108252 | -123.645121 | 0 | 2 | Offer E | Yes | 18.62 | No | Yes | DSL | 51.0 | No | Yes | No | No | No | No | No | Yes | Month-to-Month | Yes | Credit Card | 50.30 | 92.75 | 0.0 | 0 | 37.24 | 129.99 | Joined | NaN | NaN |
| 7041 | 9993-LHIEB | Male | 21 | Yes | 0 | Solana Beach | 92075 | 33.001813 | -117.263628 | 5 | 67 | Offer A | Yes | 2.12 | No | Yes | Cable | 58.0 | Yes | No | Yes | Yes | No | Yes | Yes | Yes | Two Year | No | Credit Card | 67.85 | 4627.65 | 0.0 | 0 | 142.04 | 4769.69 | Stayed | NaN | NaN |
| 7042 | 9995-HOTOH | Male | 36 | Yes | 0 | Sierra City | 96125 | 39.600599 | -120.636358 | 1 | 63 | None | No | NaN | NaN | Yes | Cable | 5.0 | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | Two Year | No | Bank Withdrawal | 59.00 | 3707.60 | 0.0 | 0 | 0.00 | 3707.60 | Stayed | NaN | NaN |